package org.wii.learner;

import static android.provider.BaseColumns._ID;
import android.app.Activity;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class ConsumedDB extends SQLiteOpenHelper {
	
	private static final int version = 1;
	
	public ConsumedDB(Context context) {
		super(context, "consumed.db", null, version);
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		db.execSQL("CREATE TABLE veggies (" + _ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
				"date TEXT NOT NULL, " +
				"numberOf UNSIGNED NOT NULL, " +
				"name TEXT NOT NULL ) ;" );
		/*db.execSQL("CREATE TABLE users (" + _ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
				"weight UNSIGNED NOT NULL, " +
				"joules UNSIGNED NOT NULL, " +
				"username TEXT NOT NULL);");*/
		
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// TODO Auto-generated method stub
		
	}
	
}
